declare @i int declare cur cursor for select spid from sysprocesses where db_name(dbid)= 'QIS_XP' open cur fetch next from cur into @i while @@fetch_status=0 begin exec('kill '+@i) fetch next from cur into @i end close cur deallocate cur 